/**
 *Copyright (c) 2024 watereyes
 * safetymanagement is licensed under Mulan PubL v2.
 * You can use this software according to the terms and conditions of the Mulan
 * PubL v2.
 * You may obtain a copy of Mulan PubL v2 at:
 *          http://license.coscl.org.cn/MulanPubL-2.0
 * THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
 * EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
 * MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
 * See the Mulan PubL v2 for more details.
 */
package com.koron.institution.mapper;

import com.koron.institution.bean.ReviseAssessment;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface ReviseAssessmentMapper {
    int deleteByPrimaryKey(String id);

    int insert(ReviseAssessment record);

    int insertSelective(ReviseAssessment record);

    ReviseAssessment selectByPrimaryKey(String id);

    int updateByPrimaryKeySelective(ReviseAssessment record);

    int updateByPrimaryKey(ReviseAssessment record);

    List<ReviseAssessment> selectByCond(@Param("corpCode") String corpCode, @Param("reviseYear") Integer reviseYear,
                                        @Param("institutionName") String institutionName, @Param("state") Integer state,
                                        @Param("start") Integer start, @Param("pageSize") Integer pageSize,
                                        @Param("exportFlag") Integer exportFlag);

    int selectTotalByCond(@Param("corpCode") String corpCode, @Param("reviseYear") Integer reviseYear,
                          @Param("institutionName") String institutionName, @Param("state") Integer state);

    List<ReviseAssessment> queryListByIds(List<String> list);

    List<ReviseAssessment> queryListByCode(@Param("corpCode") String corpCode, @Param("reviseYear") Integer reviseYear,
                                           @Param("institutionCode") String institutionCode);


    List<ReviseAssessment> queryListByYear(@Param("corpCode") String corpCode, @Param("reviseYear") Integer reviseYear);

    List<ReviseAssessment> queryDraftList(@Param("corpCode") String corpCode, @Param("reviseYear") Integer reviseYear,
                                                 @Param("institutionName") String institutionName, @Param("start") Integer start,
                                                 @Param("pageSize") Integer pageSize);

    int queryDraftListTotal(@Param("corpCode") String corpCode, @Param("reviseYear") Integer reviseYear,
                            @Param("institutionName") String institutionName);

}